CREATE EXTERNAL TABLE jms_dm.dm_customer_complaint_order_interceptor_dt
(
    network_code      string COMMENT '网点',
    network_name      string COMMENT '网点name',
    the_third_code    bigint COMMENT '异常三段码',
    effect_time_start string comment '生效开始时间',
    effect_time_end   string comment '生效结束时间',
    type              bigint COMMENT '异常类型 1异常区域 2异常网点 3异常三段码'
)
    COMMENT '客诉拦截中间表'
    PARTITIONED BY ( dt STRING COMMENT 't-1')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_customer_complaint_order_interceptor_dt'
;